﻿<%@ Page Language="vb" AutoEventWireup="false" MasterPageFile="~/Banner.Master" CodeBehind="dropdown.aspx.vb" Inherits="ETeacherforIELTS.dropdown" 
    title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <asp:DropDownList ID="DropDownList1" runat="server" 
        DataSourceID="SqlDataSource1" DataTextField="ID" DataValueField="ID">
        <asp:ListItem>Speaking Materials</asp:ListItem>
        <asp:ListItem>Listening Materials</asp:ListItem>
        <asp:ListItem>Reading Materials</asp:ListItem>
        <asp:ListItem>Writing Materials</asp:ListItem>
    </asp:DropDownList>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
        SelectCommand="SELECT [ID], [MaterialName], [Description], [Category], [File], [Picture], [VisitedCount], [UserName] FROM [MaterialCollection] WHERE ([Category] = ID)">
        <SelectParameters>
            <asp:Parameter Name="Category" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>
